Using formulas (1)

Now all the data has been entered into the table, you need to use simple formulas to calculate Total Costs, Total Revenues and Total Profits.

1. Make sure cell B9 is still selected.

2. Type =. A broken blue border is added to the cell, indicating that a formula is being entered. The Formula Tools appear.

If the formula you enter is part of a function, the spreadsheet displays the function in ‘ghost’ form beneath the text you are entering, as a guide. You do not have to copy the function.

3. Type sum(b2:b8).

4. Press ENTER on your keyboard. The contents of cells B2 down to B8 are added (or summed) together and the result displayed in the cell. The Formula Tools disappear and cell B10 is now selected.